<!DOCTYPE HTML>
<html>
<head>
<script type="text/javascript">
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
var msg;
db.transaction(function(tx) {
	tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)');
	tx.executeSql('INSERT INTO LOGS (id, log) VALUES (1, "foobar")');
	tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, "logmsg")');
	msg = '<p>完成消息创建和插入行操作。</p>';
	document.querySelector('#status').innerHTML = msg;
});
db.transaction(function(tx) {
	tx.executeSql('SELECT * FROM LOGS', [], function(tx, results) {
		var len = results.rows.length, i;
		msg = "<p>查询行数: " + len + "</p>";
		document.querySelector('#status').innerHTML += msg;
		for( i = 0; i < len; i++) {
			msg = "<p><b>" + results.rows.item(i).log + "</b></p>";
			document.querySelector('#status').innerHTML += msg;
		}
	}, null);
});
</script>
<meta charset="utf-8">
</head>
<body>
<div id="status" name="status">
</div>
</body>
</html>  
